Option 5: Regenerate Table

This option allows you to repeat the Create New Table Definitions process for a single existing SQL table and its associated Reality file.

Regenerate table offers the same methods for creating the table definition as Option 1: Create New Table Definitions:

Notes:

The Regenerate Table process is similar to that for Create New Table Definitions.

  1. On selecting option 5 from the main menu, you are prompted:

    Define Filename to be Processed…
    
    Enter Filename :

    Enter the name of the Reality file for which you wish to regenerate the SQL table. If you enter ?, a list of files is displayed, from which you can select. See Using the SQLM Menu Options.

  2. You are then prompted:

    Enter name of Table to be Regenerated:
    
    Enter Tablename :

    Enter the name of the SQL table you wish to regenerate. If you enter ?, a list of tables is displayed, from which you can select. See Using the SQLM Menu Options.

  3. You are then prompted:

    Do you wish to:
      A. Update existing Table (keeping untouched entries)
      B. Totally replace existing Table
    Enter selection (A/B/EXit):
    • If you enter A, any user-created definitions that are not overwritten will be retained.
    • If you enter B, any user-created definitions that are not overwritten will be deleted.
    • If you enter EX, you will be returned to the main menu.

Continue from step 3 of the Create New Table Definitions process.

Go to top button